home *** CD-ROM | disk | FTP | other *** search
- FindXL: A Utility that Locates Hidden Instances of Microsoft« Excel
-
- Controlling OLE objects in Microsoft Excel from Microsoft Visual Basic« 3.0 is
- one of the many ways to use the OLE Automation capabilities of Microsoft«
- Office to create custom applications. While developing and testing
- applications created in this way, a run-time error in Visual Basic 3.0 may
- leave a hidden instance of Microsoft Excel running, invisible to the Task
- Manager. FindXL is a simple tool for locating such hidden instances and making
- them visible.
-
- Visual Basic 3.0, Professional Edition contains a tool (WPS.EXE) for finding
- and eliminating dynamic link libraries and hidden executables, but that tool
- provides neither a graceful exit nor an opportunity for examining the state of
- the hidden executable. By making the hidden instance of Microsoft Excel
- visible, FindXL allows you to look at the property settings of the OLE objects
- at the time of the error.
-
- The Visual Basic 3.0 source code for FindXL demonstrates the use of the
- GetObject function with the Microsoft Excel Application object. For more
- information on GetObject, refer to Chapter 4, "Microsoft Excel Objects," in
- Programming Integrated Solutions with Microsoft Office.
-
- FindXL was built with Microsoft Visual Basic version 3.0 and incorporates the
- functionality of Microsoft Excel version 5.0.
-